Overview
Brought to you by YData
Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 183 |
| Missing cells | 15 |
| Missing cells (%) | 0.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 100.4 KiB |
| Average record size in memory | 562.0 B |
Variable types
| Text | 1 |
|---|---|
| DateTime | 4 |
| Categorical | 4 |
| Numeric | 7 |
Dataset
| Description | AIDS Clinical Trials Group 019 - HIV treatment trial |
|---|---|
| Creator | RP2 Clinical Data Harmonization Project |
| URL | HEAT Research Projects |
Variable descriptions
| study_source | Source study identifier |
|---|---|
| CD4 cell count (cells/µL) | CD4+ T lymphocyte count - immune function indicator |
| HIV viral load (copies/mL) | HIV RNA copies per mL - treatment efficacy marker |
| Albumin (g/dL) | Serum albumin - liver function and nutritional status |
| primary_date | Primary date of measurement/visit |
| Age (at enrolment) | Patient age at study enrollment |
ALT (U/L) is highly overall correlated with AST (U/L) and 4 other fields | High correlation |
AST (U/L) is highly overall correlated with ALT (U/L) | High correlation |
Patient ID is highly overall correlated with ALT (U/L) and 4 other fields | High correlation |
coordinate_source is highly overall correlated with ALT (U/L) and 5 other fields | High correlation |
month is highly overall correlated with coordinate_source and 2 other fields | High correlation |
original_record_index is highly overall correlated with ALT (U/L) and 4 other fields | High correlation |
season is highly overall correlated with Patient ID and 4 other fields | High correlation |
year is highly overall correlated with ALT (U/L) and 5 other fields | High correlation |
ALT (U/L) is highly imbalanced (59.1%) | Imbalance |
AST (U/L) has 15 (8.2%) missing values | Missing |
original_record_index is uniformly distributed | Uniform |
original_record_index has unique values | Unique |
harmonization_date has unique values | Unique |
Hematocrit (%) has 26 (14.2%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-11 10:31:57.210747 |
|---|---|
| Analysis finished | 2025-11-11 10:33:35.251591 |
| Duration | 1 minute and 38.04 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
anonymous_patient_id
Text
| Distinct | 100 |
|---|---|
| Distinct (%) | 54.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.2 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 17 |
| Min length | 17 |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | 10.4% |
Sample
| 1st row | HEAT_A5FA56CF6DEE |
|---|---|
| 2nd row | HEAT_369244B23FC3 |
| 3rd row | HEAT_25491365061F |
| 4th row | HEAT_384C0702B398 |
| 5th row | HEAT_384C0702B398 |
| Value | Count | Frequency (%) |
| heat_384c0702b398 | 4 | 2.2% |
| heat_108fa716a13b | 2 | 1.1% |
| heat_83514d501429 | 2 | 1.1% |
| heat_f4459fca5b34 | 2 | 1.1% |
| heat_e49437317781 | 2 | 1.1% |
| heat_702c7faec79a | 2 | 1.1% |
| heat_e3b7af63e12b | 2 | 1.1% |
| heat_0849de663281 | 2 | 1.1% |
| heat_b87315faeee7 | 2 | 1.1% |
| heat_7436c2f045e0 | 2 | 1.1% |
| Other values (90) | 161 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 326 | 10.5% |
| A | 307 | 9.9% |
| H | 183 | 5.9% |
| T | 183 | 5.9% |
| _ | 183 | 5.9% |
| 0 | 164 | 5.3% |
| 1 | 162 | 5.2% |
| D | 160 | 5.1% |
| F | 155 | 5.0% |
| 7 | 148 | 4.8% |
| Other values (9) | 1140 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3111 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 326 | 10.5% |
| A | 307 | 9.9% |
| H | 183 | 5.9% |
| T | 183 | 5.9% |
| _ | 183 | 5.9% |
| 0 | 164 | 5.3% |
| 1 | 162 | 5.2% |
| D | 160 | 5.1% |
| F | 155 | 5.0% |
| 7 | 148 | 4.8% |
| Other values (9) | 1140 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3111 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 326 | 10.5% |
| A | 307 | 9.9% |
| H | 183 | 5.9% |
| T | 183 | 5.9% |
| _ | 183 | 5.9% |
| 0 | 164 | 5.3% |
| 1 | 162 | 5.2% |
| D | 160 | 5.1% |
| F | 155 | 5.0% |
| 7 | 148 | 4.8% |
| Other values (9) | 1140 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3111 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 326 | 10.5% |
| A | 307 | 9.9% |
| H | 183 | 5.9% |
| T | 183 | 5.9% |
| _ | 183 | 5.9% |
| 0 | 164 | 5.3% |
| 1 | 162 | 5.2% |
| D | 160 | 5.1% |
| F | 155 | 5.0% |
| 7 | 148 | 4.8% |
| Other values (9) | 1140 |
primary_date
Date
Primary date of measurement/visit
| Distinct | 40 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 KiB |
| Minimum | 2005-05-31 00:00:00 |
|---|---|
| Maximum | 2007-06-12 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=40)
year
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 KiB |
| 2006 | |
|---|---|
| 2007 | |
| 2005 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2005 |
|---|---|
| 2nd row | 2005 |
| 3rd row | 2005 |
| 4th row | 2005 |
| 5th row | 2005 |
Common Values
| Value | Count | Frequency (%) |
| 2006 | 130 | |
| 2007 | 38 | 20.8% |
| 2005 | 15 | 8.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2006 | 130 | |
| 2007 | 38 | 20.8% |
| 2005 | 15 | 8.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 366 | |
| 2 | 183 | |
| 6 | 130 | 17.8% |
| 7 | 38 | 5.2% |
| 5 | 15 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 732 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 366 | |
| 2 | 183 | |
| 6 | 130 | 17.8% |
| 7 | 38 | 5.2% |
| 5 | 15 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 732 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 366 | |
| 2 | 183 | |
| 6 | 130 | 17.8% |
| 7 | 38 | 5.2% |
| 5 | 15 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 732 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 366 | |
| 2 | 183 | |
| 6 | 130 | 17.8% |
| 7 | 38 | 5.2% |
| 5 | 15 | 2.0% |
month
Real number (ℝ)
High correlation
| Distinct | 11 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5355191 |
| Minimum | 1 |
|---|---|
| Maximum | 11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 11 |
| Range | 10 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.7169787 |
|---|---|
| Coefficient of variation (CV) | 0.415725 |
| Kurtosis | -0.89092223 |
| Mean | 6.5355191 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.096538685 |
| Sum | 1196 |
| Variance | 7.3819732 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 7 | 29 | |
| 5 | 25 | |
| 10 | 25 | |
| 4 | 24 | |
| 8 | 18 | |
| 6 | 15 | |
| 11 | 12 | |
| 9 | 12 | |
| 2 | 9 | 4.9% |
| 3 | 8 | 4.4% |
| Value | Count | Frequency (%) |
| 1 | 6 | 3.3% |
| 2 | 9 | 4.9% |
| 3 | 8 | 4.4% |
| 4 | 24 | |
| 5 | 25 | |
| 6 | 15 | |
| 7 | 29 | |
| 8 | 18 | |
| 9 | 12 | |
| 10 | 25 |
| Value | Count | Frequency (%) |
| 11 | 12 | |
| 10 | 25 | |
| 9 | 12 | |
| 8 | 18 | |
| 7 | 29 | |
| 6 | 15 | |
| 5 | 25 | |
| 4 | 24 | |
| 3 | 8 | 4.4% |
| 2 | 9 | 4.9% |
season
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.3 KiB |
| Winter | |
|---|---|
| Autumn | |
| Spring | |
| Summer |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Winter |
|---|---|
| 2nd row | Winter |
| 3rd row | Autumn |
| 4th row | Autumn |
| 5th row | Autumn |
Common Values
| Value | Count | Frequency (%) |
| Winter | 62 | |
| Autumn | 57 | |
| Spring | 49 | |
| Summer | 15 | 8.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| winter | 62 | |
| autumn | 57 | |
| spring | 49 | |
| summer | 15 | 8.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 168 | |
| u | 129 | |
| r | 126 | |
| t | 119 | |
| i | 111 | |
| m | 87 | |
| e | 77 | |
| S | 64 | 5.8% |
| W | 62 | 5.6% |
| A | 57 | 5.2% |
| Other values (2) | 98 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1098 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 168 | |
| u | 129 | |
| r | 126 | |
| t | 119 | |
| i | 111 | |
| m | 87 | |
| e | 77 | |
| S | 64 | 5.8% |
| W | 62 | 5.6% |
| A | 57 | 5.2% |
| Other values (2) | 98 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1098 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 168 | |
| u | 129 | |
| r | 126 | |
| t | 119 | |
| i | 111 | |
| m | 87 | |
| e | 77 | |
| S | 64 | 5.8% |
| W | 62 | 5.6% |
| A | 57 | 5.2% |
| Other values (2) | 98 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1098 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 168 | |
| u | 129 | |
| r | 126 | |
| t | 119 | |
| i | 111 | |
| m | 87 | |
| e | 77 | |
| S | 64 | 5.8% |
| W | 62 | 5.6% |
| A | 57 | 5.2% |
| Other values (2) | 98 |
Hemoglobin (g/dL)
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.95082 |
| Minimum | 9 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 11 |
| median | 12 |
| Q3 | 13 |
| 95-th percentile | 14 |
| Maximum | 15 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.1826525 |
|---|---|
| Coefficient of variation (CV) | 0.098959948 |
| Kurtosis | 0.13407273 |
| Mean | 11.95082 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.095980498 |
| Sum | 2187 |
| Variance | 1.3986669 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 12 | 58 | |
| 13 | 48 | |
| 11 | 47 | |
| 10 | 15 | 8.2% |
| 14 | 7 | 3.8% |
| 15 | 5 | 2.7% |
| 9 | 3 | 1.6% |
| Value | Count | Frequency (%) |
| 9 | 3 | 1.6% |
| 10 | 15 | 8.2% |
| 11 | 47 | |
| 12 | 58 | |
| 13 | 48 | |
| 14 | 7 | 3.8% |
| 15 | 5 | 2.7% |
| Value | Count | Frequency (%) |
| 15 | 5 | 2.7% |
| 14 | 7 | 3.8% |
| 13 | 48 | |
| 12 | 58 | |
| 11 | 47 | |
| 10 | 15 | 8.2% |
| 9 | 3 | 1.6% |
Hematocrit (%)
Real number (ℝ)
Zeros
| Distinct | 20 |
|---|---|
| Distinct (%) | 10.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.448087 |
| Minimum | 0 |
|---|---|
| Maximum | 58 |
| Zeros | 26 |
| Zeros (%) | 14.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10 |
| median | 30 |
| Q3 | 45 |
| 95-th percentile | 55 |
| Maximum | 58 |
| Range | 58 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 19.038027 |
|---|---|
| Coefficient of variation (CV) | 0.69360122 |
| Kurtosis | -1.3592414 |
| Mean | 27.448087 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | -0.038707168 |
| Sum | 5023 |
| Variance | 362.44647 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 0 | 26 | |
| 45 | 19 | |
| 15 | 15 | |
| 25 | 13 | 7.1% |
| 10 | 13 | 7.1% |
| 30 | 13 | 7.1% |
| 35 | 13 | 7.1% |
| 40 | 13 | 7.1% |
| 50 | 13 | 7.1% |
| 5 | 12 | 6.6% |
| Other values (10) | 33 |
| Value | Count | Frequency (%) |
| 0 | 26 | |
| 3 | 2 | 1.1% |
| 5 | 12 | |
| 10 | 13 | |
| 15 | 15 | |
| 16 | 2 | 1.1% |
| 20 | 4 | 2.2% |
| 24 | 2 | 1.1% |
| 25 | 13 | |
| 30 | 13 |
| Value | Count | Frequency (%) |
| 58 | 6 | 3.3% |
| 57 | 3 | 1.6% |
| 55 | 8 | |
| 53 | 2 | 1.1% |
| 50 | 13 | |
| 48 | 2 | 1.1% |
| 45 | 19 | |
| 43 | 2 | 1.1% |
| 40 | 13 | |
| 35 | 13 |
White blood cell count (×10³/µL)
Real number (ℝ)
| Distinct | 47 |
|---|---|
| Distinct (%) | 25.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.6535519 |
| Minimum | 2.2 |
|---|---|
| Maximum | 10.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 KiB |
Quantile statistics
| Minimum | 2.2 |
|---|---|
| 5-th percentile | 2.71 |
| Q1 | 3.6 |
| median | 4.3 |
| Q3 | 5.55 |
| 95-th percentile | 7.5 |
| Maximum | 10.7 |
| Range | 8.5 |
| Interquartile range (IQR) | 1.95 |
Descriptive statistics
| Standard deviation | 1.5826935 |
|---|---|
| Coefficient of variation (CV) | 0.3401044 |
| Kurtosis | 2.8535255 |
| Mean | 4.6535519 |
| Median Absolute Deviation (MAD) | 0.9 |
| Skewness | 1.348183 |
| Sum | 851.6 |
| Variance | 2.5049186 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 4.2 | 10 | 5.5% |
| 3.9 | 9 | 4.9% |
| 3.6 | 8 | 4.4% |
| 5.2 | 7 | 3.8% |
| 4.3 | 7 | 3.8% |
| 3.2 | 7 | 3.8% |
| 4.9 | 7 | 3.8% |
| 3.7 | 7 | 3.8% |
| 3.1 | 7 | 3.8% |
| 4.6 | 6 | 3.3% |
| Other values (37) | 108 |
| Value | Count | Frequency (%) |
| 2.2 | 2 | 1.1% |
| 2.5 | 4 | |
| 2.6 | 2 | 1.1% |
| 2.7 | 2 | 1.1% |
| 2.8 | 4 | |
| 2.9 | 3 | |
| 3 | 4 | |
| 3.1 | 7 | |
| 3.2 | 7 | |
| 3.3 | 4 |
| Value | Count | Frequency (%) |
| 10.7 | 2 | |
| 10.6 | 2 | |
| 8 | 2 | |
| 7.6 | 2 | |
| 7.5 | 4 | |
| 7.1 | 2 | |
| 6.7 | 3 | |
| 6.5 | 2 | |
| 6.4 | 2 | |
| 6.3 | 2 |
ALT (U/L)
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.7 KiB |
| 1.0 | |
|---|---|
| 2.0 | 15 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 2.0 |
| 4th row | 2.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 168 | |
| 2.0 | 15 | 8.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 168 | |
| 2.0 | 15 | 8.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 183 | |
| 0 | 183 | |
| 1 | 168 | |
| 2 | 15 | 2.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 549 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 183 | |
| 0 | 183 | |
| 1 | 168 | |
| 2 | 15 | 2.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 549 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 183 | |
| 0 | 183 | |
| 1 | 168 | |
| 2 | 15 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 549 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 183 | |
| 0 | 183 | |
| 1 | 168 | |
| 2 | 15 | 2.7% |
AST (U/L)
Real number (ℝ)
High correlation Missing
| Distinct | 78 |
|---|---|
| Distinct (%) | 46.4% |
| Missing | 15 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.233929 |
| Minimum | 36.8 |
|---|---|
| Maximum | 76.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 KiB |
Quantile statistics
| Minimum | 36.8 |
|---|---|
| 5-th percentile | 41.2 |
| Q1 | 51.95 |
| median | 58.8 |
| Q3 | 65.775 |
| 95-th percentile | 72.77 |
| Maximum | 76.2 |
| Range | 39.4 |
| Interquartile range (IQR) | 13.825 |
Descriptive statistics
| Standard deviation | 9.5483129 |
|---|---|
| Coefficient of variation (CV) | 0.16396477 |
| Kurtosis | -0.70805753 |
| Mean | 58.233929 |
| Median Absolute Deviation (MAD) | 7.05 |
| Skewness | -0.22172206 |
| Sum | 9783.3 |
| Variance | 91.170279 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 39.2 | 4 | 2.2% |
| 59.4 | 4 | 2.2% |
| 45.6 | 4 | 2.2% |
| 54 | 4 | 2.2% |
| 50 | 4 | 2.2% |
| 54.7 | 4 | 2.2% |
| 71.6 | 4 | 2.2% |
| 65.7 | 4 | 2.2% |
| 48.4 | 3 | 1.6% |
| 70.1 | 3 | 1.6% |
| Other values (68) | 130 | |
| (Missing) | 15 | 8.2% |
| Value | Count | Frequency (%) |
| 36.8 | 2 | |
| 39.2 | 4 | |
| 40.5 | 2 | |
| 41.2 | 2 | |
| 42.9 | 1 | 0.5% |
| 43.5 | 2 | |
| 43.8 | 2 | |
| 45.5 | 2 | |
| 45.6 | 4 | |
| 45.8 | 2 |
| Value | Count | Frequency (%) |
| 76.2 | 1 | 0.5% |
| 75.4 | 2 | |
| 74.6 | 1 | 0.5% |
| 74.4 | 2 | |
| 74 | 2 | |
| 73.4 | 1 | 0.5% |
| 71.6 | 4 | |
| 71 | 2 | |
| 70.4 | 2 | |
| 70.1 | 3 |
Patient ID
Real number (ℝ)
High correlation
| Distinct | 100 |
|---|---|
| Distinct (%) | 54.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1110185.9 |
| Minimum | 1110031 |
|---|---|
| Maximum | 1110289 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 KiB |
Quantile statistics
| Minimum | 1110031 |
|---|---|
| 5-th percentile | 1110040.1 |
| Q1 | 1110132.5 |
| median | 1110194 |
| Q3 | 1110251.5 |
| 95-th percentile | 1110283 |
| Maximum | 1110289 |
| Range | 258 |
| Interquartile range (IQR) | 119 |
Descriptive statistics
| Standard deviation | 75.721443 |
|---|---|
| Coefficient of variation (CV) | 6.8206094 × 10-5 |
| Kurtosis | -0.86496361 |
| Mean | 1110185.9 |
| Median Absolute Deviation (MAD) | 61 |
| Skewness | -0.48213463 |
| Sum | 2.0316402 × 108 |
| Variance | 5733.7369 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1110037 | 4 | 2.2% |
| 1110088 | 2 | 1.1% |
| 1110047 | 2 | 1.1% |
| 1110040 | 2 | 1.1% |
| 1110149 | 2 | 1.1% |
| 1110157 | 2 | 1.1% |
| 1110158 | 2 | 1.1% |
| 1110080 | 2 | 1.1% |
| 1110079 | 2 | 1.1% |
| 1110139 | 2 | 1.1% |
| Other values (90) | 161 |
| Value | Count | Frequency (%) |
| 1110031 | 1 | 0.5% |
| 1110035 | 1 | 0.5% |
| 1110036 | 1 | 0.5% |
| 1110037 | 4 | |
| 1110039 | 1 | 0.5% |
| 1110040 | 2 | |
| 1110041 | 1 | 0.5% |
| 1110044 | 1 | 0.5% |
| 1110047 | 2 | |
| 1110048 | 1 | 0.5% |
| Value | Count | Frequency (%) |
| 1110289 | 1 | |
| 1110288 | 2 | |
| 1110286 | 2 | |
| 1110285 | 2 | |
| 1110284 | 2 | |
| 1110283 | 2 | |
| 1110281 | 2 | |
| 1110279 | 2 | |
| 1110278 | 2 | |
| 1110277 | 1 |
original_record_index
Real number (ℝ)
High correlation Uniform Unique
| Distinct | 183 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91 |
| Minimum | 0 |
|---|---|
| Maximum | 182 |
| Zeros | 1 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9.1 |
| Q1 | 45.5 |
| median | 91 |
| Q3 | 136.5 |
| 95-th percentile | 172.9 |
| Maximum | 182 |
| Range | 182 |
| Interquartile range (IQR) | 91 |
Descriptive statistics
| Standard deviation | 52.971691 |
|---|---|
| Coefficient of variation (CV) | 0.58210649 |
| Kurtosis | -1.2 |
| Mean | 91 |
| Median Absolute Deviation (MAD) | 46 |
| Skewness | 0 |
| Sum | 16653 |
| Variance | 2806 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | 0.5% |
| 1 | 1 | 0.5% |
| 2 | 1 | 0.5% |
| 3 | 1 | 0.5% |
| 4 | 1 | 0.5% |
| 5 | 1 | 0.5% |
| 6 | 1 | 0.5% |
| 7 | 1 | 0.5% |
| 8 | 1 | 0.5% |
| 9 | 1 | 0.5% |
| Other values (173) | 173 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 182 | 1 | |
| 181 | 1 | |
| 180 | 1 | |
| 179 | 1 | |
| 178 | 1 | |
| 177 | 1 | |
| 176 | 1 | |
| 175 | 1 | |
| 174 | 1 | |
| 173 | 1 |
harmonization_date
Date
Unique
| Distinct | 183 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 KiB |
| Minimum | 2025-08-11 15:41:05.869140 |
|---|---|
| Maximum | 2025-08-11 15:41:05.904148 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
visit_date
Date
| Distinct | 40 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 KiB |
| Minimum | 2005-05-31 00:00:00 |
|---|---|
| Maximum | 2007-06-12 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=40)
coordinate_source
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.3 KiB |
| JHB_ACTG_021 | |
|---|---|
| JHB_ACTG_019 |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | JHB_ACTG_019 |
|---|---|
| 2nd row | JHB_ACTG_019 |
| 3rd row | JHB_ACTG_019 |
| 4th row | JHB_ACTG_019 |
| 5th row | JHB_ACTG_019 |
Common Values
| Value | Count | Frequency (%) |
| JHB_ACTG_021 | 151 | |
| JHB_ACTG_019 | 32 | 17.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| jhb_actg_021 | 151 | |
| jhb_actg_019 | 32 | 17.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 366 | |
| J | 183 | |
| H | 183 | |
| B | 183 | |
| A | 183 | |
| C | 183 | |
| T | 183 | |
| G | 183 | |
| 0 | 183 | |
| 1 | 183 | |
| Other values (2) | 183 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2196 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| _ | 366 | |
| J | 183 | |
| H | 183 | |
| B | 183 | |
| A | 183 | |
| C | 183 | |
| T | 183 | |
| G | 183 | |
| 0 | 183 | |
| 1 | 183 | |
| Other values (2) | 183 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2196 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| _ | 366 | |
| J | 183 | |
| H | 183 | |
| B | 183 | |
| A | 183 | |
| C | 183 | |
| T | 183 | |
| G | 183 | |
| 0 | 183 | |
| 1 | 183 | |
| Other values (2) | 183 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2196 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| _ | 366 | |
| J | 183 | |
| H | 183 | |
| B | 183 | |
| A | 183 | |
| C | 183 | |
| T | 183 | |
| G | 183 | |
| 0 | 183 | |
| 1 | 183 | |
| Other values (2) | 183 |
primary_date_parsed
Date
| Distinct | 40 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 KiB |
| Minimum | 2005-05-31 00:00:00 |
|---|---|
| Maximum | 2007-06-12 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=40)
Interactions
Correlations
| ALT (U/L) | AST (U/L) | Hematocrit (%) | Hemoglobin (g/dL) | Patient ID | White blood cell count (×10³/µL) | coordinate_source | month | original_record_index | season | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ALT (U/L) | 1.000 | 1.000 | 0.207 | 0.323 | 0.677 | 0.000 | 0.620 | 0.381 | 0.852 | 0.238 | 0.997 |
| AST (U/L) | 1.000 | 1.000 | -0.151 | 0.279 | -0.050 | 0.272 | 0.215 | 0.080 | -0.050 | 0.284 | 0.356 |
| Hematocrit (%) | 0.207 | -0.151 | 1.000 | -0.257 | 0.160 | 0.102 | 0.184 | 0.062 | 0.160 | 0.158 | 0.204 |
| Hemoglobin (g/dL) | 0.323 | 0.279 | -0.257 | 1.000 | -0.125 | 0.067 | 0.155 | 0.091 | -0.125 | 0.137 | 0.229 |
| Patient ID | 0.677 | -0.050 | 0.160 | -0.125 | 1.000 | -0.059 | 0.677 | 0.206 | 1.000 | 0.668 | 0.679 |
| White blood cell count (×10³/µL) | 0.000 | 0.272 | 0.102 | 0.067 | -0.059 | 1.000 | 0.081 | 0.031 | -0.059 | 0.210 | 0.114 |
| coordinate_source | 0.620 | 0.215 | 0.184 | 0.155 | 0.677 | 0.081 | 1.000 | 0.727 | 0.852 | 0.675 | 0.657 |
| month | 0.381 | 0.080 | 0.062 | 0.091 | 0.206 | 0.031 | 0.727 | 1.000 | 0.206 | 0.983 | 0.590 |
| original_record_index | 0.852 | -0.050 | 0.160 | -0.125 | 1.000 | -0.059 | 0.852 | 0.206 | 1.000 | 0.745 | 0.909 |
| season | 0.238 | 0.284 | 0.158 | 0.137 | 0.668 | 0.210 | 0.675 | 0.983 | 0.745 | 1.000 | 0.544 |
| year | 0.997 | 0.356 | 0.204 | 0.229 | 0.679 | 0.114 | 0.657 | 0.590 | 0.909 | 0.544 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| anonymous_patient_id | primary_date | year | month | season | Hemoglobin (g/dL) | Hematocrit (%) | White blood cell count (×10³/µL) | ALT (U/L) | AST (U/L) | Patient ID | original_record_index | harmonization_date | visit_date | coordinate_source | primary_date_parsed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1520 | HEAT_A5FA56CF6DEE | 2005-06-01 | 2005 | 6 | Winter | 13.0 | 25.0 | 2.9 | 2.0 | NaN | 1110031 | 0.0 | 2025-08-11T15:41:05.869140 | 2005-06-01 | JHB_ACTG_019 | 2005-06-01 |
| 1521 | HEAT_369244B23FC3 | 2005-06-01 | 2005 | 6 | Winter | 12.0 | 57.0 | 6.2 | 2.0 | NaN | 1110035 | 1.0 | 2025-08-11T15:41:05.869376 | 2005-06-01 | JHB_ACTG_019 | 2005-06-01 |
| 1522 | HEAT_25491365061F | 2005-05-31 | 2005 | 5 | Autumn | 13.0 | 15.0 | 6.2 | 2.0 | NaN | 1110036 | 2.0 | 2025-08-11T15:41:05.869603 | 2005-05-31 | JHB_ACTG_019 | 2005-05-31 |
| 1523 | HEAT_384C0702B398 | 2005-05-31 | 2005 | 5 | Autumn | 12.0 | 30.0 | 4.6 | 2.0 | NaN | 1110037 | 3.0 | 2025-08-11T15:41:05.869814 | 2005-05-31 | JHB_ACTG_019 | 2005-05-31 |
| 1524 | HEAT_384C0702B398 | 2005-05-31 | 2005 | 5 | Autumn | 12.0 | 30.0 | 4.6 | 2.0 | NaN | 1110037 | 4.0 | 2025-08-11T15:41:05.870020 | 2005-05-31 | JHB_ACTG_019 | 2005-05-31 |
| 1525 | HEAT_384C0702B398 | 2005-06-01 | 2005 | 6 | Winter | 12.0 | 30.0 | 4.6 | 2.0 | NaN | 1110037 | 5.0 | 2025-08-11T15:41:05.870225 | 2005-06-01 | JHB_ACTG_019 | 2005-06-01 |
| 1526 | HEAT_384C0702B398 | 2005-06-01 | 2005 | 6 | Winter | 12.0 | 30.0 | 4.6 | 2.0 | NaN | 1110037 | 6.0 | 2025-08-11T15:41:05.870429 | 2005-06-01 | JHB_ACTG_019 | 2005-06-01 |
| 1527 | HEAT_577544911E15 | 2005-06-02 | 2005 | 6 | Winter | 15.0 | 0.0 | 5.3 | 2.0 | NaN | 1110039 | 7.0 | 2025-08-11T15:41:05.870648 | 2005-06-02 | JHB_ACTG_019 | 2005-06-02 |
| 1528 | HEAT_F4459FCA5B34 | 2005-05-31 | 2005 | 5 | Autumn | 15.0 | 25.0 | 3.9 | 2.0 | NaN | 1110040 | 8.0 | 2025-08-11T15:41:05.870852 | 2005-05-31 | JHB_ACTG_019 | 2005-05-31 |
| 1529 | HEAT_F4459FCA5B34 | 2005-06-01 | 2005 | 6 | Winter | 15.0 | 25.0 | 3.9 | 2.0 | NaN | 1110040 | 9.0 | 2025-08-11T15:41:05.871055 | 2005-06-01 | JHB_ACTG_019 | 2005-06-01 |
| anonymous_patient_id | primary_date | year | month | season | Hemoglobin (g/dL) | Hematocrit (%) | White blood cell count (×10³/µL) | ALT (U/L) | AST (U/L) | Patient ID | original_record_index | harmonization_date | visit_date | coordinate_source | primary_date_parsed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1693 | HEAT_6F07D7CBD31B | 2007-05-10 | 2007 | 5 | Autumn | 11.0 | 45.0 | 2.8 | 1.0 | 52.7 | 1110283 | 173.0 | 2025-08-11T15:41:05.902427 | 2007-05-10 | JHB_ACTG_021 | 2007-05-10 |
| 1694 | HEAT_8A27E9EFC9C1 | 2007-05-10 | 2007 | 5 | Autumn | 11.0 | 48.0 | 5.2 | 1.0 | 69.1 | 1110284 | 174.0 | 2025-08-11T15:41:05.902624 | 2007-05-10 | JHB_ACTG_021 | 2007-05-10 |
| 1695 | HEAT_8A27E9EFC9C1 | 2007-05-10 | 2007 | 5 | Autumn | 11.0 | 48.0 | 5.2 | 1.0 | 69.1 | 1110284 | 175.0 | 2025-08-11T15:41:05.902813 | 2007-05-10 | JHB_ACTG_021 | 2007-05-10 |
| 1696 | HEAT_546B86594237 | 2007-05-10 | 2007 | 5 | Autumn | 12.0 | 45.0 | 5.6 | 1.0 | 61.2 | 1110285 | 176.0 | 2025-08-11T15:41:05.903006 | 2007-05-10 | JHB_ACTG_021 | 2007-05-10 |
| 1697 | HEAT_546B86594237 | 2007-05-10 | 2007 | 5 | Autumn | 12.0 | 45.0 | 5.6 | 1.0 | 61.2 | 1110285 | 177.0 | 2025-08-11T15:41:05.903195 | 2007-05-10 | JHB_ACTG_021 | 2007-05-10 |
| 1698 | HEAT_307294D069C2 | 2007-05-11 | 2007 | 5 | Autumn | 13.0 | 0.0 | 4.3 | 1.0 | 52.2 | 1110286 | 178.0 | 2025-08-11T15:41:05.903384 | 2007-05-11 | JHB_ACTG_021 | 2007-05-11 |
| 1699 | HEAT_307294D069C2 | 2007-05-11 | 2007 | 5 | Autumn | 13.0 | 0.0 | 4.3 | 1.0 | 52.2 | 1110286 | 179.0 | 2025-08-11T15:41:05.903581 | 2007-05-11 | JHB_ACTG_021 | 2007-05-11 |
| 1700 | HEAT_15C6FF1F74F9 | 2007-05-11 | 2007 | 5 | Autumn | 12.0 | 40.0 | 4.7 | 1.0 | 59.8 | 1110288 | 180.0 | 2025-08-11T15:41:05.903771 | 2007-05-11 | JHB_ACTG_021 | 2007-05-11 |
| 1701 | HEAT_15C6FF1F74F9 | 2007-05-11 | 2007 | 5 | Autumn | 12.0 | 40.0 | 4.7 | 1.0 | 59.8 | 1110288 | 181.0 | 2025-08-11T15:41:05.903960 | 2007-05-11 | JHB_ACTG_021 | 2007-05-11 |
| 1702 | HEAT_945EB2014C3C | 2007-06-12 | 2007 | 6 | Winter | 12.0 | 35.0 | 3.7 | 1.0 | 65.4 | 1110289 | 182.0 | 2025-08-11T15:41:05.904148 | 2007-06-12 | JHB_ACTG_021 | 2007-06-12 |